package com.pm2.dao.WorkCalendar;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.pm2.entity.workCalendar.WorkCalendar;

public interface WorkCalendarDao extends JpaRepository<WorkCalendar, Long> {

	public WorkCalendar findById(int id);
	public List<WorkCalendar> findByYear(int year);
	
	
	@Query("from WorkCalendar where day_date >= ?1 and day_date <= ?2")
	public List<WorkCalendar> findByStardAndEndDate(Date start_date,Date end_date);
}
